package org.example.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;

import javax.sql.DataSource;

@Configuration
@PropertySource(value = "classpath:db.properties")
public class jdbcCnfig {

    @Value(("${jdbc.driver}"))
    private   String  driver;
    @Value(("${jdbc.url}"))
    private  String   url;
    @Value(("${jdbc.username}"))
    private   String  username;
    @Value(("${jdbc.password}"))
    private    String password;

    @Bean
    public DataSource dataSource() {
        DruidDataSource dataSource=new DruidDataSource();
        dataSource.setDriverClassName(driver);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        return dataSource;

    }

//    注入事务管理器
@Bean
    public PlatformTransactionManager transactionManager (DataSource dataSource){
        DataSourceTransactionManager tdm = new DataSourceTransactionManager();
        tdm.setDataSource(dataSource);//指明数据库连接池，保证事务正确执行
        return tdm;
    }


}
